/**
 * @description  : 涉案物品 sql
 * @descriptionDetail : 涉案物品 sql
 * @copyright    : 浙江烟草
 * @author       : mc
 * @create       : 2022-12-03 13:54:47
 */
const goods = {
  createSQL: 'CREATE TABLE IF NOT EXISTS GOODS (' +
		'id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,' +
		'tid VARCHAR,' +
		'caseCode VARCHAR,' +
		'userId VARCHAR,' + 
		'content TEXT)',
  insertSQL: 'INSERT INTO GOODS(tid, caseCode, userId, content)' +
		' VALUES(?,?,?,?)',
  queryWhereSQL: 'select * from GOODS where caseCode=? AND userId=?',
  deleteSQL: "delete from GOODS where caseCode=? AND userId=?",
  createSQL_H5: {
    name: "GOODS",
    sql:"++id,&tid,caseCode,[caseCode+userId],userId,content",
    insertSQL_H5: ['tid','caseCode', 'userId', 'content',],
    sqlObj:{
      tid:'',
      caseCode : '',
      userId : '',
      content : '',
    },
    queryKeys:["caseCode","userId",],
  },
}

module.exports = {
  goods,
}
